/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : mybatistest

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 24/08/2022 15:48:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_departments
-- ----------------------------
DROP TABLE IF EXISTS `t_departments`;
CREATE TABLE `t_departments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_departments
-- ----------------------------
BEGIN;
INSERT INTO `t_departments` VALUES (1, '行政', '二楼');
INSERT INTO `t_departments` VALUES (2, '技术', '二楼');
COMMIT;

-- ----------------------------
-- Table structure for t_employees
-- ----------------------------
DROP TABLE IF EXISTS `t_employees`;
CREATE TABLE `t_employees` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `salary` decimal(10,2) DEFAULT NULL,
  `dept_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_employees
-- ----------------------------
BEGIN;
INSERT INTO `t_employees` VALUES (1, '杰哥', 11.11, 1);
INSERT INTO `t_employees` VALUES (2, '苏曦', 9.90, 1);
INSERT INTO `t_employees` VALUES (3, 'wyf', 0.75, 1);
INSERT INTO `t_employees` VALUES (4, '吴永强', 0.50, 2);
INSERT INTO `t_employees` VALUES (5, '刘雨生', 1.00, 2);
COMMIT;

-- ----------------------------
-- Table structure for t_passenger
-- ----------------------------
DROP TABLE IF EXISTS `t_passenger`;
CREATE TABLE `t_passenger` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sex` char(1) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_passenger
-- ----------------------------
BEGIN;
INSERT INTO `t_passenger` VALUES (1, '老王', '男', '2022-08-24');
INSERT INTO `t_passenger` VALUES (2, '小美', '女', '2022-08-24');
INSERT INTO `t_passenger` VALUES (3, '小红', '女', '2022-08-24');
INSERT INTO `t_passenger` VALUES (4, '小孙', '女', '2022-08-24');
COMMIT;

-- ----------------------------
-- Table structure for t_passports
-- ----------------------------
DROP TABLE IF EXISTS `t_passports`;
CREATE TABLE `t_passports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nationality` varchar(100) DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `passenger_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_passports
-- ----------------------------
BEGIN;
INSERT INTO `t_passports` VALUES (1, 'China', '2022-08-31', 1);
INSERT INTO `t_passports` VALUES (2, 'China', '2022-08-28', 2);
INSERT INTO `t_passports` VALUES (3, 'china', '2022-09-30', 4);
INSERT INTO `t_passports` VALUES (4, 'china', '2022-08-31', 3);
COMMIT;

-- ----------------------------
-- Table structure for t_stu_sub
-- ----------------------------
DROP TABLE IF EXISTS `t_stu_sub`;
CREATE TABLE `t_stu_sub` (
  `stuid` int DEFAULT NULL,
  `subid` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_stu_sub
-- ----------------------------
BEGIN;
INSERT INTO `t_stu_sub` VALUES (1, 1);
INSERT INTO `t_stu_sub` VALUES (1, 2);
INSERT INTO `t_stu_sub` VALUES (2, 2);
INSERT INTO `t_stu_sub` VALUES (3, 4);
INSERT INTO `t_stu_sub` VALUES (3, 5);
COMMIT;

-- ----------------------------
-- Table structure for t_students
-- ----------------------------
DROP TABLE IF EXISTS `t_students`;
CREATE TABLE `t_students` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_students
-- ----------------------------
BEGIN;
INSERT INTO `t_students` VALUES (1, '李尧', '不详');
INSERT INTO `t_students` VALUES (2, '田贵宾', '女');
INSERT INTO `t_students` VALUES (3, '范建伟', '中');
COMMIT;

-- ----------------------------
-- Table structure for t_subjects
-- ----------------------------
DROP TABLE IF EXISTS `t_subjects`;
CREATE TABLE `t_subjects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `grade` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_subjects
-- ----------------------------
BEGIN;
INSERT INTO `t_subjects` VALUES (1, 'Java', 1);
INSERT INTO `t_subjects` VALUES (2, '数据结构和算法', 2);
INSERT INTO `t_subjects` VALUES (3, '语文', 3);
INSERT INTO `t_subjects` VALUES (4, '支持向量机', 4);
INSERT INTO `t_subjects` VALUES (5, '卷积神经网络', 5);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
